package com.zhongyu.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.zhongyu.pojo.LinkUser;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface LinkUserMapper extends BaseMapper<LinkUser> {

   @Select("SELECT t1.*,t2.id AS t2id,t2.username FROM smbms_link_user t1 JOIN smbms_user t2 ON t1.user_id=t2.id")
   List<LinkUser> findAll();

}
